Jeff M.
Jeff M.
Reactions
-
Re: Formula to Capture Active Projects Assigned to an Individual ONLY
Sure, you'll want to repeat the same 3 status variables for each name. Try putting this one in there and see if that gives you the correct results. =COUNTIFS({TE}, "AK", {status}, "In …1 · -
Re: Checking for conflicting assignment dates across two columns
I think I solved it for you!!!!!! I created a column named "1st Guide Flag" and plugged in this formula. =IF((ISBLANK([1st Guide]@row)), 0, IF(COUNTIFS([1st Guide]:[1st Guide], @cell = [1st…1 · -
Re: Formula to Capture Active Projects Assigned to an Individual ONLY
Try this formula and see if this fixes your error. Otherwise you may need to account for the parent format and add the descendants function. DESCENDANTS Function | Smartsheet Learning Center =COUNTIF…1 · -
Re: Hi All
Try your formula with these modifications. =COUNTIFS(Status:Status, "Open", Unque:Unique, "Unique")1 · -
Re: Network Days where same day = 0
You could just add -1 at the end of the formula to subtract 1 day. Add [Holidays] after end date if you want to account for them as well. =NETWORKDAYS([Start Date]@row, [End Date]@row) - 11 ·
